Overview

Dataset statistics

Number of variables13
Number of observations167693
Missing cells480
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.6 MiB
Average record size in memory104.0 B

Variable types

Numeric12
Categorical1

Warnings

ignore has constant value "0" Constant
open time is highly correlated with open and 4 other fieldsHigh correlation
open is highly correlated with open time and 4 other fieldsHigh correlation
high is highly correlated with open time and 4 other fieldsHigh correlation
low is highly correlated with open time and 4 other fieldsHigh correlation
close is highly correlated with open time and 4 other fieldsHigh correlation
volume is highly correlated with quote_asset_volume and 3 other fieldsHigh correlation
close_time is highly correlated with open time and 4 other fieldsHigh correlation
quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
number_of_trades is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_base_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
open time is highly correlated with open and 4 other fieldsHigh correlation
open is highly correlated with open time and 4 other fieldsHigh correlation
high is highly correlated with open time and 4 other fieldsHigh correlation
low is highly correlated with open time and 4 other fieldsHigh correlation
close is highly correlated with open time and 4 other fieldsHigh correlation
volume is highly correlated with quote_asset_volume and 3 other fieldsHigh correlation
close_time is highly correlated with open time and 4 other fieldsHigh correlation
quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
number_of_trades is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_base_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
open time is highly correlated with close_timeHigh correlation
open is highly correlated with high and 2 other fieldsHigh correlation
high is highly correlated with open and 2 other fieldsHigh correlation
low is highly correlated with open and 2 other fieldsHigh correlation
close is highly correlated with open and 2 other fieldsHigh correlation
volume is highly correlated with quote_asset_volume and 3 other fieldsHigh correlation
close_time is highly correlated with open timeHigh correlation
quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
number_of_trades is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_base_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
taker_buy_quote_asset_volume is highly correlated with volume and 3 other fieldsHigh correlation
low is highly correlated with open time and 4 other fieldsHigh correlation
open time is highly correlated with low and 4 other fieldsHigh correlation
close_time is highly correlated with low and 4 other fieldsHigh correlation
number_of_trades is highly correlated with volume and 3 other fieldsHigh correlation
volume is highly correlated with number_of_trades and 3 other fieldsHigh correlation
taker_buy_quote_asset_volume is highly correlated with number_of_trades and 3 other fieldsHigh correlation
high is highly correlated with low and 4 other fieldsHigh correlation
taker_buy_base_asset_volume is highly correlated with number_of_trades and 3 other fieldsHigh correlation
open is highly correlated with low and 4 other fieldsHigh correlation
quote_asset_volume is highly correlated with number_of_trades and 3 other fieldsHigh correlation
close is highly correlated with low and 4 other fieldsHigh correlation
volume is highly skewed (γ1 = 20.69985771) Skewed
taker_buy_base_asset_volume is highly skewed (γ1 = 27.29847463) Skewed
taker_buy_quote_asset_volume is highly skewed (γ1 = 22.69475006) Skewed
open time is uniformly distributed Uniform
close_time is uniformly distributed Uniform
open time has unique values Unique
close_time has unique values Unique
volume has 33414 (19.9%) zeros Zeros
quote_asset_volume has 33414 (19.9%) zeros Zeros
number_of_trades has 33414 (19.9%) zeros Zeros
taker_buy_base_asset_volume has 70012 (41.8%) zeros Zeros
taker_buy_quote_asset_volume has 70012 (41.8%) zeros Zeros

Reproduction

Analysis started2022-02-14 19:16:12.398787
Analysis finished2022-02-14 19:16:56.090242
Duration43.69 seconds
Software versionpandas-profiling v3.0.0
Download configurationconfig.json

Variables

open time
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct167693
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.629688153 × 1012
Minimum1.6145568 × 1012
Maximum1.64479662 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1.6145568 × 1012
5-th percentile1.616071428 × 1012
Q11.62213426 × 1012
median1.62969714 × 1012
Q31.63725048 × 1012
95-th percentile1.643287392 × 1012
Maximum1.64479662 × 1012
Range3.023982 × 1010
Interquartile range (IQR)1.511622 × 1010

Descriptive statistics

Standard deviation8729706727
Coefficient of variation (CV)0.005356673121
Kurtosis-1.20006685
Mean1.629688153 × 1012
Median Absolute Deviation (MAD)7558200000
Skewness-0.001590850162
Sum2.732872955 × 1017
Variance7.620777954 × 1019
MonotonicityStrictly increasing
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.62151722 × 10121
 
< 0.1%
1.61873136 × 10121
 
< 0.1%
1.63716822 × 10121
 
< 0.1%
1.6215939 × 10121
 
< 0.1%
1.64401092 × 10121
 
< 0.1%
1.64064096 × 10121
 
< 0.1%
1.6293582 × 10121
 
< 0.1%
1.6182468 × 10121
 
< 0.1%
1.63817586 × 10121
 
< 0.1%
1.62048186 × 10121
 
< 0.1%
Other values (167683)167683
> 99.9%
ValueCountFrequency (%)
1.6145568 × 10121
< 0.1%
1.61455698 × 10121
< 0.1%
1.61455716 × 10121
< 0.1%
1.61455734 × 10121
< 0.1%
1.61455752 × 10121
< 0.1%
1.6145577 × 10121
< 0.1%
1.61455788 × 10121
< 0.1%
1.61455806 × 10121
< 0.1%
1.61455824 × 10121
< 0.1%
1.61455842 × 10121
< 0.1%
ValueCountFrequency (%)
1.64479662 × 10121
< 0.1%
1.64479644 × 10121
< 0.1%
1.64479626 × 10121
< 0.1%
1.64479608 × 10121
< 0.1%
1.6447959 × 10121
< 0.1%
1.64479572 × 10121
< 0.1%
1.64479554 × 10121
< 0.1%
1.64479536 × 10121
< 0.1%
1.64479518 × 10121
< 0.1%
1.644795 × 10121
< 0.1%

open
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct109864
Distinct (%)65.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3031.148652
Minimum1415.01
Maximum4861.97
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1415.01
5-th percentile1771.492
Q12290.52
median3062.54
Q33788.48
95-th percentile4443.128
Maximum4861.97
Range3446.96
Interquartile range (IQR)1497.96

Descriptive statistics

Standard deviation861.7681297
Coefficient of variation (CV)0.2843041462
Kurtosis-1.083984556
Mean3031.148652
Median Absolute Deviation (MAD)746.59
Skewness0.129313889
Sum508302410.9
Variance742644.3093
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3340.559
 
< 0.1%
3123.8452
 
< 0.1%
3224.7951
 
< 0.1%
3262.740
 
< 0.1%
2923.737
 
< 0.1%
3182.1532
 
< 0.1%
330032
 
< 0.1%
3006.5928
 
< 0.1%
2596.4428
 
< 0.1%
3067.6327
 
< 0.1%
Other values (109854)167307
99.8%
ValueCountFrequency (%)
1415.011
< 0.1%
1416.681
< 0.1%
1418.621
< 0.1%
1420.641
< 0.1%
1422.221
< 0.1%
1424.11
< 0.1%
1424.551
< 0.1%
1424.71
< 0.1%
1425.141
< 0.1%
1425.621
< 0.1%
ValueCountFrequency (%)
4861.972
< 0.1%
4860.451
< 0.1%
4855.181
< 0.1%
4853.491
< 0.1%
4853.171
< 0.1%
4851.021
< 0.1%
4850.851
< 0.1%
4850.141
< 0.1%
48501
< 0.1%
4849.81
< 0.1%

high
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct106082
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3033.034522
Minimum1415.01
Maximum4864.53
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1415.01
5-th percentile1772.336
Q12293.05
median3064.28
Q33789.95
95-th percentile4444.18
Maximum4864.53
Range3449.52
Interquartile range (IQR)1496.9

Descriptive statistics

Standard deviation861.8730925
Coefficient of variation (CV)0.2841619791
Kurtosis-1.08339271
Mean3033.034522
Median Absolute Deviation (MAD)746.28
Skewness0.1285407293
Sum508618658.2
Variance742825.2276
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3340.559
 
< 0.1%
3123.8452
 
< 0.1%
3224.7951
 
< 0.1%
3262.739
 
< 0.1%
330038
 
< 0.1%
2923.736
 
< 0.1%
3182.1532
 
< 0.1%
214031
 
< 0.1%
2668.9431
 
< 0.1%
2456.9629
 
< 0.1%
Other values (106072)167295
99.8%
ValueCountFrequency (%)
1415.011
< 0.1%
1416.681
< 0.1%
1418.621
< 0.1%
1420.641
< 0.1%
1424.551
< 0.1%
1424.71
< 0.1%
1425.621
< 0.1%
1426.571
< 0.1%
1426.641
< 0.1%
1427.191
< 0.1%
ValueCountFrequency (%)
4864.531
< 0.1%
4863.251
< 0.1%
4861.971
< 0.1%
4860.451
< 0.1%
48601
< 0.1%
4859.41
< 0.1%
4857.421
< 0.1%
4856.831
< 0.1%
4853.911
< 0.1%
4853.491
< 0.1%

low
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct106512
Distinct (%)63.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3028.993787
Minimum1320
Maximum4858.83
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1320
5-th percentile1770.57
Q12287.97
median3060.74
Q33786.12
95-th percentile4441.18
Maximum4858.83
Range3538.83
Interquartile range (IQR)1498.15

Descriptive statistics

Standard deviation861.591016
Coefficient of variation (CV)0.284447931
Kurtosis-1.08446744
Mean3028.993787
Median Absolute Deviation (MAD)747.08
Skewness0.1300496673
Sum507941055.2
Variance742339.0788
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3340.559
 
< 0.1%
3123.8452
 
< 0.1%
3224.7952
 
< 0.1%
3262.741
 
< 0.1%
2923.736
 
< 0.1%
2596.4432
 
< 0.1%
3182.1532
 
< 0.1%
2568.7331
 
< 0.1%
3006.5929
 
< 0.1%
330028
 
< 0.1%
Other values (106502)167301
99.8%
ValueCountFrequency (%)
13201
< 0.1%
1413.511
< 0.1%
1413.881
< 0.1%
1416.681
< 0.1%
1418.621
< 0.1%
1422.221
< 0.1%
1423.631
< 0.1%
1423.861
< 0.1%
1424.551
< 0.1%
1424.71
< 0.1%
ValueCountFrequency (%)
4858.831
< 0.1%
4853.91
< 0.1%
4851.021
< 0.1%
4849.051
< 0.1%
4848.971
< 0.1%
4848.391
< 0.1%
4848.381
< 0.1%
4847.851
< 0.1%
4847.841
< 0.1%
4846.671
< 0.1%

close
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct102300
Distinct (%)61.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3031.053097
Minimum1413.51
Maximum4858.83
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1413.51
5-th percentile1771.33
Q12290.43
median3062.43
Q33788.18
95-th percentile4442.644
Maximum4858.83
Range3445.32
Interquartile range (IQR)1497.75

Descriptive statistics

Standard deviation861.7340972
Coefficient of variation (CV)0.2843018811
Kurtosis-1.083983989
Mean3031.053097
Median Absolute Deviation (MAD)746.68
Skewness0.1292738289
Sum508286387
Variance742585.6543
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3340.560
 
< 0.1%
3224.7952
 
< 0.1%
3123.8452
 
< 0.1%
3262.740
 
< 0.1%
330038
 
< 0.1%
2923.736
 
< 0.1%
3182.1532
 
< 0.1%
2596.4429
 
< 0.1%
2568.7328
 
< 0.1%
2668.9428
 
< 0.1%
Other values (102290)167298
99.8%
ValueCountFrequency (%)
1413.511
< 0.1%
1413.881
< 0.1%
1416.681
< 0.1%
1418.621
< 0.1%
1423.331
< 0.1%
1424.551
< 0.1%
1424.71
< 0.1%
1424.741
< 0.1%
1424.941
< 0.1%
1424.951
< 0.1%
ValueCountFrequency (%)
4858.831
< 0.1%
4855.671
< 0.1%
4853.91
< 0.1%
4852.831
< 0.1%
4851.121
< 0.1%
4851.022
< 0.1%
4850.911
< 0.1%
4850.871
< 0.1%
4850.411
< 0.1%
4850.191
< 0.1%

volume
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct98498
Distinct (%)58.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.197698078
Minimum0
Maximum739.03261
Zeros33414
Zeros (%)19.9%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10.0249
median1.03538
Q33.4964
95-th percentile12.593764
Maximum739.03261
Range739.03261
Interquartile range (IQR)3.4715

Descriptive statistics

Standard deviation8.05923681
Coefficient of variation (CV)2.5203245
Kurtosis1087.809066
Mean3.197698078
Median Absolute Deviation (MAD)1.03538
Skewness20.69985771
Sum536231.5837
Variance64.95129796
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
033414
 
19.9%
1331
 
0.2%
0.5254
 
0.2%
0.4219
 
0.1%
0.6203
 
0.1%
0.2191
 
0.1%
0.05189
 
0.1%
0.0139182
 
0.1%
0.1175
 
0.1%
0.7171
 
0.1%
Other values (98488)132364
78.9%
ValueCountFrequency (%)
033414
19.9%
1 × 10-54
 
< 0.1%
2 × 10-52
 
< 0.1%
3 × 10-51
 
< 0.1%
4 × 10-51
 
< 0.1%
5 × 10-51
 
< 0.1%
6 × 10-52
 
< 0.1%
8 × 10-51
 
< 0.1%
9 × 10-51
 
< 0.1%
0.000111
 
< 0.1%
ValueCountFrequency (%)
739.032611
< 0.1%
629.922521
< 0.1%
503.490541
< 0.1%
480.440941
< 0.1%
468.682571
< 0.1%
415.499191
< 0.1%
398.494651
< 0.1%
322.69571
< 0.1%
279.8071
< 0.1%
273.816111
< 0.1%

close_time
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct167693
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.629688333 × 1012
Minimum1.61455698 × 1012
Maximum1.6447968 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1.61455698 × 1012
5-th percentile1.616071608 × 1012
Q11.62213444 × 1012
median1.62969732 × 1012
Q31.63725066 × 1012
95-th percentile1.643287572 × 1012
Maximum1.6447968 × 1012
Range3.023982 × 1010
Interquartile range (IQR)1.511622 × 1010

Descriptive statistics

Standard deviation8729706728
Coefficient of variation (CV)0.00535667253
Kurtosis-1.20006685
Mean1.629688333 × 1012
Median Absolute Deviation (MAD)7558200000
Skewness-0.001590850265
Sum2.732873257 × 1017
Variance7.620777956 × 1019
MonotonicityStrictly increasing
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.63081134 × 10121
 
< 0.1%
1.64172888 × 10121
 
< 0.1%
1.63538226 × 10121
 
< 0.1%
1.64293974 × 10121
 
< 0.1%
1.62189612 × 10121
 
< 0.1%
1.62848592 × 10121
 
< 0.1%
1.63570788 × 10121
 
< 0.1%
1.61889822 × 10121
 
< 0.1%
1.63106298 × 10121
 
< 0.1%
1.61668944 × 10121
 
< 0.1%
Other values (167683)167683
> 99.9%
ValueCountFrequency (%)
1.61455698 × 10121
< 0.1%
1.61455716 × 10121
< 0.1%
1.61455734 × 10121
< 0.1%
1.61455752 × 10121
< 0.1%
1.6145577 × 10121
< 0.1%
1.61455788 × 10121
< 0.1%
1.61455806 × 10121
< 0.1%
1.61455824 × 10121
< 0.1%
1.61455842 × 10121
< 0.1%
1.6145586 × 10121
< 0.1%
ValueCountFrequency (%)
1.6447968 × 10121
< 0.1%
1.64479662 × 10121
< 0.1%
1.64479644 × 10121
< 0.1%
1.64479626 × 10121
< 0.1%
1.64479608 × 10121
< 0.1%
1.6447959 × 10121
< 0.1%
1.64479572 × 10121
< 0.1%
1.64479554 × 10121
< 0.1%
1.64479536 × 10121
< 0.1%
1.64479518 × 10121
< 0.1%

quote_asset_volume
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct133837
Distinct (%)79.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9299.26115
Minimum0
Maximum1536197.879
Zeros33414
Zeros (%)19.9%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q174.929608
median2844.204384
Q310252.18735
95-th percentile37044.20866
Maximum1536197.879
Range1536197.879
Interquartile range (IQR)10177.25774

Descriptive statistics

Standard deviation22851.17329
Coefficient of variation (CV)2.457310631
Kurtosis605.1538805
Mean9299.26115
Median Absolute Deviation (MAD)2844.204384
Skewness16.25909648
Sum1559421000
Variance522176120.6
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
033414
 
19.9%
26.115837
 
< 0.1%
26.4513526
 
< 0.1%
26.5133126
 
< 0.1%
22.53356
 
< 0.1%
26.4266825
 
< 0.1%
43.3395055
 
< 0.1%
20.5530355
 
< 0.1%
12.132225
 
< 0.1%
43.0811045
 
< 0.1%
Other values (133827)134229
80.0%
ValueCountFrequency (%)
033414
19.9%
0.01697691
 
< 0.1%
0.01832741
 
< 0.1%
0.0235571
 
< 0.1%
0.03301241
 
< 0.1%
0.0368031
 
< 0.1%
0.05504911
 
< 0.1%
0.06539281
 
< 0.1%
0.07368361
 
< 0.1%
0.1036981
 
< 0.1%
ValueCountFrequency (%)
1536197.8791
< 0.1%
1508185.4351
< 0.1%
1379494.5861
< 0.1%
1201363.1261
< 0.1%
1043585.2911
< 0.1%
991519.48571
< 0.1%
928001.90591
< 0.1%
898101.91681
< 0.1%
894888.64511
< 0.1%
894225.52291
< 0.1%

number_of_trades
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct277
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.899286196
Minimum0
Maximum1046
Zeros33414
Zeros (%)19.9%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median4
Q311
95-th percentile33
Maximum1046
Range1046
Interquartile range (IQR)10

Descriptive statistics

Standard deviation16.10302781
Coefficient of variation (CV)1.809474092
Kurtosis297.0969966
Mean8.899286196
Median Absolute Deviation (MAD)4
Skewness9.693089299
Sum1492348
Variance259.3075045
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
033414
19.9%
120326
12.1%
214595
 
8.7%
311669
 
7.0%
49635
 
5.7%
57936
 
4.7%
66918
 
4.1%
75976
 
3.6%
85288
 
3.2%
94617
 
2.8%
Other values (267)47319
28.2%
ValueCountFrequency (%)
033414
19.9%
120326
12.1%
214595
8.7%
311669
 
7.0%
49635
 
5.7%
57936
 
4.7%
66918
 
4.1%
75976
 
3.6%
85288
 
3.2%
94617
 
2.8%
ValueCountFrequency (%)
10461
< 0.1%
9141
< 0.1%
7671
< 0.1%
7461
< 0.1%
6961
< 0.1%
4191
< 0.1%
4041
< 0.1%
3901
< 0.1%
3851
< 0.1%
3621
< 0.1%

taker_buy_base_asset_volume
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct66978
Distinct (%)39.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.518533806
Minimum0
Maximum629.4356
Zeros70012
Zeros (%)41.8%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.0629
Q31.2877
95-th percentile6.672394
Maximum629.4356
Range629.4356
Interquartile range (IQR)1.2877

Descriptive statistics

Standard deviation5.519537423
Coefficient of variation (CV)3.634780734
Kurtosis1792.726341
Mean1.518533806
Median Absolute Deviation (MAD)0.0629
Skewness27.29847463
Sum254647.4896
Variance30.46529336
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
070012
41.8%
0.5327
 
0.2%
1318
 
0.2%
0.4255
 
0.2%
0.6243
 
0.1%
0.65221
 
0.1%
0.7217
 
0.1%
0.1204
 
0.1%
0.3198
 
0.1%
0.05194
 
0.1%
Other values (66968)95504
57.0%
ValueCountFrequency (%)
070012
41.8%
1 × 10-53
 
< 0.1%
2 × 10-52
 
< 0.1%
4 × 10-51
 
< 0.1%
7 × 10-53
 
< 0.1%
8 × 10-51
 
< 0.1%
0.000110
 
< 0.1%
0.000131
 
< 0.1%
0.000141
 
< 0.1%
0.000161
 
< 0.1%
ValueCountFrequency (%)
629.43561
< 0.1%
471.478231
< 0.1%
391.535181
< 0.1%
250.483321
< 0.1%
247.313071
< 0.1%
237.580961
< 0.1%
223.333211
< 0.1%
221.950321
< 0.1%
219.002161
< 0.1%
210.02721
< 0.1%

taker_buy_quote_asset_volume
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct96935
Distinct (%)57.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4376.024455
Minimum0
Maximum1507021.742
Zeros70012
Zeros (%)41.8%
Negative0
Negative (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median176.3552
Q33555.792
95-th percentile20001.84303
Maximum1507021.742
Range1507021.742
Interquartile range (IQR)3555.792

Descriptive statistics

Standard deviation15685.6432
Coefficient of variation (CV)3.584450536
Kurtosis1092.031597
Mean4376.024455
Median Absolute Deviation (MAD)176.3552
Skewness22.69475006
Sum733828668.9
Variance246039402.7
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
070012
41.8%
26.5169629
 
< 0.1%
43.3395058
 
< 0.1%
26.1680258
 
< 0.1%
26.279288
 
< 0.1%
22.53357
 
< 0.1%
22.7903557
 
< 0.1%
26.4085477
 
< 0.1%
22.42706187
 
< 0.1%
26.2059217
 
< 0.1%
Other values (96925)97613
58.2%
ValueCountFrequency (%)
070012
41.8%
0.0196551
 
< 0.1%
0.03301241
 
< 0.1%
0.03507421
 
< 0.1%
0.0368031
 
< 0.1%
0.04786761
 
< 0.1%
0.09356721
 
< 0.1%
0.1432041
 
< 0.1%
0.1707531
 
< 0.1%
0.2047221
 
< 0.1%
ValueCountFrequency (%)
1507021.7421
< 0.1%
878958.72241
< 0.1%
874219.45021
< 0.1%
840253.30051
< 0.1%
837964.82241
< 0.1%
804816.68441
< 0.1%
787409.96581
< 0.1%
666322.13581
< 0.1%
655168.95491
< 0.1%
636510.76651
< 0.1%

ignore
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
0
167693 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters167693
Distinct characters1
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0167693
100.0%

Length

Histogram of lengths of the category

Pie chart

ValueCountFrequency (%)
0167693
100.0%

Most occurring characters

ValueCountFrequency (%)
0167693
100.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number167693
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0167693
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common167693
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0167693
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII167693
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0167693
100.0%

return
Real number (ℝ)

Distinct156249
Distinct (%)93.4%
Missing480
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean0.003216872948
Minimum-0.4134126678
Maximum0.4627397083
Zeros11
Zeros (%)< 0.1%
Negative77397
Negative (%)46.2%
Memory size1.3 MiB

Quantile statistics

Minimum-0.4134126678
5-th percentile-0.07872063596
Q1-0.0250697918
median0.004006037919
Q30.03391047352
95-th percentile0.08089207883
Maximum0.4627397083
Range0.8761523761
Interquartile range (IQR)0.05898026531

Descriptive statistics

Standard deviation0.05083771007
Coefficient of variation (CV)15.803456
Kurtosis3.460966565
Mean0.003216872948
Median Absolute Deviation (MAD)0.02953656949
Skewness-0.1179855097
Sum537.9029762
Variance0.002584472765
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-0.00286184702921
 
< 0.1%
-0.0198065393917
 
< 0.1%
0.0370752824217
 
< 0.1%
-0.0306866118114
 
< 0.1%
-0.0165431170613
 
< 0.1%
-0.0107941680313
 
< 0.1%
-0.0601955128213
 
< 0.1%
0.00551645884413
 
< 0.1%
0.0311524161313
 
< 0.1%
0.0156373555613
 
< 0.1%
Other values (156239)167066
99.6%
(Missing)480
 
0.3%
ValueCountFrequency (%)
-0.41341266781
< 0.1%
-0.40809897841
< 0.1%
-0.40381341411
< 0.1%
-0.37239215691
< 0.1%
-0.36637943591
< 0.1%
-0.36480348781
< 0.1%
-0.35511936771
< 0.1%
-0.35480697431
< 0.1%
-0.35395884971
< 0.1%
-0.35394239461
< 0.1%
ValueCountFrequency (%)
0.46273970831
< 0.1%
0.43222254991
< 0.1%
0.42616929471
< 0.1%
0.42181457211
< 0.1%
0.417244741
< 0.1%
0.38812215081
< 0.1%
0.38021255491
< 0.1%
0.37765087031
< 0.1%
0.37748136611
< 0.1%
0.37633960571
< 0.1%

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

open timeopenhighlowclosevolumeclose_timequote_asset_volumenumber_of_tradestaker_buy_base_asset_volumetaker_buy_quote_asset_volumeignorereturn
016145568000001422.221429.471422.221423.334.2102616145569799996009.59802982.765883945.1818540NaN
116145569800001420.641420.641413.881413.8811.07088161455715999915683.606427130.14750209.4219750NaN
216145571600001415.011415.011413.511413.516.4296916145573399999091.38186390.000000.0000000NaN
316145573400001416.681416.681416.681416.681.2000016145575199991700.01600010.000000.0000000NaN
416145575200001418.621418.621418.621418.620.01992161455769999928.25891010.000000.0000000NaN
516145577000001425.651445.861425.651445.863.6178816145578799995213.79100153.471395004.9475330NaN
616145578800001444.441444.441443.571443.573.7539216145580599995420.24255440.000000.0000000NaN
716145580600001441.271441.271441.271441.270.01790161455823999925.79873320.0089512.8993660NaN
816145582400001441.271441.271441.271441.270.0000016145584199990.00000000.000000.0000000NaN
916145584200001441.771441.771441.771441.771.2991416145585999991873.06107810.000000.0000000NaN

Last rows

open timeopenhighlowclosevolumeclose_timequote_asset_volumenumber_of_tradestaker_buy_base_asset_volumetaker_buy_quote_asset_volumeignorereturn
16768316447950000002879.872879.872879.872879.870.17361644795179999499.94543210.00000.0000000-0.012881
16768416447951800002879.872879.872879.872879.870.000016447953599990.00000000.00000.0000000-0.012881
16768516447953600002879.872879.872879.872879.870.000016447955399990.00000000.00000.0000000-0.006729
16768616447955400002877.432877.432877.432877.430.20381644795719999586.42023420.2038586.4202340-0.007571
16768716447957200002878.582878.582878.582878.583.4748164479589999910002.48978453.474810002.4897840-0.007174
16768816447959000002882.672890.482882.672890.483.4838164479607999910042.75430533.483810042.7543050-0.003070
16768916447960800002890.482890.482890.482890.480.000016447962599990.00000000.00000.0000000-0.003070
16769016447962600002890.482890.482890.482890.480.000016447964399990.00000000.00000.0000000-0.003070
16769116447964400002889.422889.422888.432888.430.18701644796619999540.15017130.013940.1629380-0.003777
16769216447966200002873.252873.252873.252873.250.0139164479679999939.93817510.00000.0000000-0.009012